You can embed the sound on your site to auto play when the page loads.
The HTML tag that plays music from a website is the >EMBED< tag. Inside the embed tag, you need to define several things (attributes).
SRC="the location of the audio file"
AUTOSTART="true or false"
LOOP="true or false"
HIDDEN="true or false"
WIDTH="145" HEIGHT="30"
Here is a sample bit of code that has all of the attributes included:
<EMBED SRC="mysong.mid" AUTOSTART="true" LOOP="true" HIDDEN="false" WIDTH="145" HEIGHT="30"></embed>
So now you can add music or sound to your site. Now all you have to do is decide what you want it to be. Check out the Bravenet Audio Archive for thousands of great sounds clips to choose from.