Its history was built on fossil fuels – but now the site’s future depends on its reinvention as a green energy industrial hub.