We have several ceilidh sets that are based on song tunes: one of our Gay Gordons sets starts with "The Uist Tramping Song" (Come along, come along), then goes into "Mairi's Wedding", followed by "The Piper o' Dundee".
There is, in fact, a "Mairi's Wedding" dance, but it's based on 40 bars, so you have to play around a bit with adding extra repeats into the tune - which would slightly throw the song!
And another few sets that we get get out around Burns Nights in the 2 ceilidh bands I play in:
1) A Man's a Man/Rantin' Rovin' Robin/Corn Rigs (Gay Gordons)
2) Ae Fond Kiss/Ye Banks and Braes/My Love is like a Red Red Rose - all waltzes (the latter proving that you can convert anything into waltz time.
3)Ye Banks and Braes/Ca' the Yowes/ A Man's a Man - also all waltzes tho' I can't stand the last one in 3/4!
4) My Love she's but a Lassie Yet/Willie Brewed a peck o' Maut/This is no my ain Lassie/Corn Rigs - all reels: work for a Dashing White Sergeant.
And Scottish singer, Janet Russell, now based in Yorkshire, has developed this to a fine art of singing and dancing at the same time - if you've got enough breath for that!