Scottish bagpipes are not used in The Lord of the Rings. You should mean the Irish bagpipes, which are commonly called tin flutes. If there is, the music name is "The Dear Hobbit" and the full version is "The End of the Bag", but the latter is hard to find.