Councillors say a £1 levy added to hotel bills would raise extra funds, but some believe it would put tourists off from visiting.