"Red is the Rose" is what the Irish call this tune. The Scots called "Loch Lomond". This tune is arranged for the Great Highland Bagpipe. The sheet music with the practice chanter audio is free!
If you are looking for a book that has all of the tunes that you need to play to get started as a bagpiper, consider our book "Bagpipes For Beginners". This starts with all of the Massed Band Tunes and includes tunes for every occasion. Click on this link for more information: Bagpipes For Beginners