To some it may have looked like a lost cause; another grand Scottish building condemned to ruin. David Johnston on a challenge that took decades ...