Years of cuts to budgets have left many Scots councils struggling to deliver essential services.