New Northern Powerhouse Rail hub to help unlock 5,000-home regeneration