You don't play songs on pipes, you play tunes.

For me, though, it's "The Little Cascade"

Sorry......couldn't find it on pipes........ but this gives you an idea of how it sounds.