UK-based water firm Harrogate has announced a multi-million pound investment at its North Yorkshire production facility.