The face of Catholicism in Scotland has changed significantly since the last Pope visited the country almost 30 years ago.