Dundee museum set to open for summer