The investment, part of a £128m support package for culture venues across the UK, follows a period in which the centre has struggled financially