Pioneering legislation will transform transport across the North of England, underlining the government's commitment to the Northern Powerhouse.