I know this tune as ´The Swans Swim Bonnie´

There is a version with not so naughty lyrics sung by Anne Wylie. It also has a great fiddle/Pipe break in between the verses.