There's a great tune for the metrical version of the 23rd Psalm(often sung to Crimmond). As far as I'm concerned, it's written Brother James' Air. Or even Brother James Air. Not Brother James's Air.
But obviosuly, when you say it, wou say "Brother James's Air".