Major public-private sector collaboration to create £40m housing-led regeneration