Councillors told the situation was generating foul odours and driving away tourists and shoppers