Hi all,
Ok here are my hot tips for Scottish players.
1. Rory Campbell. He plays with several well-respected bands, Deaf Shepherd and Old Blind Dogs for example, and has done several solo/duo cds. He mostly plays low whistle but some high whistle too. I recommend a cd he made with Malcolm Stitt (bouzouki/guitar player in Deaf Shepherd, also session musician extraordinaire) called Field of Bells. There is some great whistle work on this. He is also Piping God and a thoroughly nice chap...
2. Martyn Bennett. Son of Margaret Bennett, Gaelic singer and ethnology expert. Has produced 3 or 4 solo cds. Try his first one for a lot of good tunes to learn on the whistle.
Warning: neither of these guys is for the faint-hearted! They are both quite into 'fusion' of modern dance music etc with traditional tunes, so a lot of their stuff involves samples, drum machines etc. Personally I think it's great but it's not everyone's cup of tea... if you prefer the more traditional sound have a listen to any of the Deaf Shepherd albums.
Also they are both pipers too, these are not cds that focus on the whistle all the time. But you will get a good idea of the Scottish style from them. And bear in mind that all the GHB pipe tunes work on a D whistle because pipes use only G natural, so no pesky G sharps to worry about.
I don't know how easy it will be to find these cds across the pond, so have a look at the Music Scotland website
http://www.musicscotland.com which does free delivery worldwide and carries all of the above artists. Put "Rory Campbell" or "Martyn Bennett" into the search box and it'll bring up lots to choose from.
Battlefield Band etc that were mentioned above are all good choices too