There's an alternate universe where these kinds of problems are entirely dealt with through nuisance and noise laws and that kind of thing: the bar is permitted wherever people want to build it, however, the local authorities come down hard on people being a PITA. So if it's a wine bar where middle aged people sip quietly and chat about business, it's not going to bother anyone. The rowdy biker bar probably won't last long in a residential area.
That sounds pretty bad. If you make everything illegal then only selectively enforce the laws...
In my experience, in a smaller town, these things are primarily used as a weapon to punish otherwise bad businesses.
For example, we had a bar whose patrons became a neighborhood nuisance. They began to enforce the letter of the law for every violation until the bar closed.