The highly anticipated museum, designed by Japanese architect Kengo Kuma and opening to the public this weekend, is part of a £1 billion plan to regenerate Dundee’s waterfront and change the Scottish city’s public image from post-industrial wasteland to cultural hub.