Hundreds of farmers and owners of commercial businesses in an area of north Cork are to receive a reduction of up to 40% in their water bills as their supply in early summer was deemed unfit for consumption.