In moderation, sure. Away from the kids, fine, provided they don't come back home too wasted/high to be able to act accordingly should something arise with the kids. It's the parents who do everything in front of the kids, and overdo it (as my husband did, which is why I made him go dry) that are the issue. Any parent who takes such a photo worries the hell out of me, because it's not showing proper responsibility.
As I said, I know I sound reactionary to some, but that's because I work with a lot of kids from dysfunctional homes thanks to parental substance abuse. I've had preschoolers explain how to measure and wrap packets of hard drugs for selling.