Scottish National Gallery of Modern Art marks centenary of the birth of the city's famous artistic son