Let me be the first to lower the tone and suggest one of my favourites, I Belong To Glasgow, by WIll Fyffe.

http://www.youtube.com/watch?v=Oww8HXLsxDw

He was actually from Dundee, and met his end falling out of a hotel window, perhaps "under the affluence of incohol"?