I've had a go at some lyrics.
I've not written a tune.
The metre is 8.6.8.6 and so if you want to try out the lyrics, there are loads of psalm/hymn tunes that fit the words, even if otherwise unsuitable. Actually a slow, grand tune could work quite well.
The lyrics:
We are, we are, we are, we are ...
we are the Caley Jags!
We outshine Clachnacuddin and
we're better than the Stags!
We are a famous football club!
Our name is known afar!
We're feared by Berwick Rangers and
by Celtic and Stranraer!
Apologies to fans of Berwick and Stranraer.
Those clubs are mentioned for reasons of geography rather than history.