Will this affect my relationship with my water retailer?

No, this won’t impact your relationship with your water retailer. Since the charges were initially incorrect, it’s within your rights as a customer to dispute them if you have evidence of an error.