I gotta ask, which city or even country? The United States has extensive and varied laws on public consumption and intoxication. Places like Las Vegas are the exception, not the norm.
but most places do have bars and serve alcohol in restaurants, which counts as public consumption of alcohol
this is true
and it is my experience that most places consider restaurants and such a place where a member of the public can be charged with "public intoxication," though to my knowledge that's not a thing that's punished here