Water bills will rise by an average of £123 this year in the biggest hit to customer pockets since the industry was privatised 36 years ago, it has emerged.