If you want excellent piping combined with other folk music, I would suggest The Tannahill Weavers. Any of their CDs would be excellent, but Capernaum and Leaving St. Kilda are probably my favorites. The "Good Drying Set" on Leaving St. Kilda is some of the best piping anywhere, hands down.

The Weavers are what got me started in piping; I hope someday to sound as good as some of their pipers.