Just be smart about it.
We make an effort to always use coozies, and make sure cans/bottles are disposed of, not laying around the parking lot etc..
Basically, just don't flaunt it and be smart. there are always idiots getting rowdy with a beer in their hand. You ususally see them in the back of a patrol car by nights end.
My experience has been that the foot patrol guys are very tolerant as long as you are being smart. Last home game we had two come and catch up on scores with us at our tailgating spot. They had no problem with us drinking.