That tune is called the little cascade written by G.S. MacLennan. He got the idea from the tune listening to a leaky faucet.
If you guys want to hear great piping with with a twist try these guys.
Mark Saul
Peatbog Fairies
R.S. MacDonald