Survey reveals public view of council tax rise