The dry summer and high costs of bulk water were blamed by the council for sporting clubs struggling to pay bills.