The mayor welcomes 'investment we have been crying out for' as the government promises the 'biggest transformation to travel in the north in a generation'