It does indeed have lyrics, written by Robert Burns in 1790: I remember singing it in primary school! It uses something like the second tune in your link above, Joe.

THE CAMPBELLS ARE COMING

The Campbells are comin, Oho, Oho!
The Campbells are comin, Oho, Oho!
The Campbells are comin to bonie Lochleven,
The Campbells are comin Oho, Oho!

Upon the Lomonds I lay, I lay,
Upon the Lomonds I lay, I lay,
I looked down to bonie Lochleven,
And saw three bonie perches play.

Great Argyle he goes before,
He maks his cannons and guns to roar,
Wi' sound o' trumpet, pipe and drum
The Campbells are comin Oho, Oho!

The Campbells they are a' in arms
Their loyal faith and truth to show,
Wi' banners rattling in the wind
The Campbells are comin Oho, Oho!

The Campbells are comin, Oho, Oho!
The Campbells are comin, Oho, Oho!
The Campbells are comin to bonie Lochleven,
The Campbells are comin Oho, Oho!