The iconic Cowcaddens Streetscape in the Fifties is one of Alasdair Gray’s best-known works and what he called his “best big oil painting