The city is the first in the country to impose a ban in a direct response to "unacceptable" scenes by intoxicated visitors.