Use flash or don't do it. You can add sounds using the "play sound" behaviour in dreamweaver, but it is not relaible. Depending on the software on the suer computer, the sound may play, or it might open software to play the sound, which kind of spoils the effect!
I've not seen it done effectibely in any other way other than in flash.