Unless videos or music is the purpose of the site I would avoid sound on the web page. Apart from the fact that it personally annoys me, 1/4 of my relatives still use dial-up and it slows the page down a lot.
The second I hear some annoying sounds on a website is the second that I exit the page. It provides no value at all to your site and just ruins the user experience, especially if they are listening to loud music.
Unless asked for, no Music should be used, it can be quite irritating.
also, music either costs you money (for rights) or is a loop (which is terribly boring).
I don't mind sound in websites as long as we can turn it off. I have been to a few sites where the sound kept repeating. I didn't mind it the first time, but its a little distracting if you are trying to read the homepage and it keeps playing, and you can't turn it off. I went into one site and the music played on every page. I found that to be a bit annoying.