When i visit someone's page, the first thing that start's playing is some crazy song. First thing i do is to get out of their page. It is kinda annoying.
If you think having sound will increase the usability or the theme of your website. Sure do it. I personally like the website www[dot]dreamworksstudios[dot]com . It is a perfect mix of music and interface.