Why don't you start with your first basic concern? You don't want your kids to grow up seeing a beer can in his hand 24/7. That is a really valid request and you are perfectly within reason to ask him to either drink when the kids are not around, or not show them the round the clock drinking.
Yes, I know that opens up another can of worms, which is you might be asking him to drink secretly, but, you maybe work on that as step 2.
Your request to remove the constant beer can attached to the palm of his hand may stimulate some thought there, and it can only be good.