Councillors cost ratepayers over £670,000 a year