Councils have been left with a near-£100 million bill to cover the increase in national insurance, the local authority body has said.