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.