Drinking laws are local, or at least county level in most places. My town doesn’t have any about drinking in public at all, just about drunkenness. The next town over is no public drinking at all, not even on your porch.
So there’s no single answer, it will depend on where your are within the US. Couldn’t say anything about Canada though, never been and don’t know enough.
Be warned though, you may not be able to board a flight if you’re drunk.