This revamp and extension of Aberdeen’s prime exhibition space for visual arts is an impressively mature project in a city that until now has enjoyed little good modern architecture, writes Alan Dunlop. Photography Dapple Photography