All local authorities can learn from a failed project by Highland Council to provide heat and power to residents, which had landed the local authority with a £11.5m bill, Audit Scotland has warned.