Up to £100 billion will pour into the north over the next 15 years for the generation and transmission of renewable energy.