An Allianz-led consortium has agreed to acquire the UK's largest water-only supplier, Affinity Water.