Survey shows voters think council tax is unfair and most worry about how they will pay it