Councillors demand action as locals say dirty streets are driving visitors away