They say you are not supposed to have drugs or alcohol on the water while operating a boot but I have seen many of people kayaking or canoeing with beer ina coozie. They don't want broken glass or litter anywhere.
Just don't get caught by the Rangers.
Not sure about alcohol policy but I was just there and did not see any signs and they didn't ask to look in bags/cooler.
Thanks! Your answer is awaiting moderation.