download
O Willie's rare (sheet music)
The words appear in Allan Ramsay's 'Tea-table Miscellany' of 1724, and the complete song, with its traditional air, in Johnson's 'The Scots Musical Museum' of 1803.
You can find this sheet music in any of these products: