The Dundee gallery is one of the beneficiaries of Scottish government funding aimed at “flagship cultural venues”.