Local authorities spend around a quarter of the council tax they collect on pension contributions for staff.