Ice cream vans in the Uk seem to mostly use popeye the sailor man as their tune
Round our way "Greensleaves" seems to be popular. Always loud. Though there is a law that says they should only make a noise while they are moving. I believe is is a national law (England & Wales anyway). Maybe tied in with horns etc.