North East mayor hopes to radically upgrade travel infrastructure across Northumberland, Tyne and Wear, and County Durham by 2040