Through site-specific installations, this visually splendid exhibition explores the role of the artist’s studio in contemporary practices