Two major industrial sites in Northumberland and County Durham are set for a multi-million pound cash injection.