The social care system is “at breaking point”, a local government official warns.