Appliancist features two lovely hob-top kettles today, both of which are said to have "melodic whistles". A picture just doesn't cut it. If you have either one of these you should upload a video of what they sound like! I've fingers crossed that the Alessi "Train Whistle" model on the right lives up to its name.
Both kettles cost well over $200.