Scottish smallpipes don’t commonly have keys, so no, they only have a flat leading tone.
There could well be other types of small pipes (as opposed to smallpipes) that have sharp leading tones.
An A smallpipe chanter is in two sharps. The notes are g a b c# d e f# g a
Getting a high g# would be a trick. There’s not much room between g and a. If you wanted only g# and not g, you could move the hole.