With a vast power station gallery and new and revamped museums, the city is aiming to rival St Petersburg