Councillors are told National Insurance hike and lack of new funding for adult social care leaves little option but to increase levy