"The Scottish Folksinger" and "101 Scottish Songs" are suggestions I would enthusiastically second. So is Ewan MacColl's "Songs and Ballads of Scotland". if you can find it.
Well worth looking at Dick Gaughan's website, he has the lyrics for his repertoire on there.