Multi-million-pound investment deal will unlock comprehensive regeneration