I am looking to find out if Dreamweaver 8 for Mac might be compatible with Intel Core Duo and Snow Leopard.
Nope it's PowerPC and Adobe never intended on releasing updates:
I stand corrected. Rosetta will run on 10.6 but it was not installed as part of the default installation of the Mac. If you received a computer that did not have 10.5 or earlier on it before, then Rosetta is a separate installer on the installation CD. See the following KB article for details: