The Accounts Commission says Scottish local authorities have coped well with financial pressures but continue to face tough challenges from reducing budgets and growing demands for services.