The number of retired UK council staff receiving six-figure pensions has reached a record high, sparking debates over funding and fairness amid rising council tax and stretched local government budgets.