Councils across Scotland are facing punishing budget cuts, but with higher demand than ever for public services, the pressure on local authorities has never been greater.