Council finances are increasingly unsustainable and in need of reform, the public spending watchdog has warned.