From a contemporary art festival taking over an entire city to a very pink pop culture moment at Kelvingrove, June is an exceptional month for exhibitions across Scotland. Here’s where to go.