Australians rate their local councils as the best-performing tier of government but paradoxically, many also see them as the most expendable.