Claudia Massie on the spectacular new galleries that showcase the best of Scottish art for the first time