The huge project will create thousands of jobs and unlock billions of pounds of economic value for the North over the next decade.