Nic Jones' arrangement of "The Lakes of Shilyn" setting an up tempo version of "The Banks of the Bann/Lord of all Hopefulness" to a tale about some poor sod getting drowned in an enchanted lake.
A bit like Richard's post there is a North East Music Hall song "The Fire Doon on the Quay" which has a rollicking tune and chorus to a most tragic tale.