A mental health charity has called George Michael “stupid and naive” after he was pictured smiling and lighting what appeared to be a cannabis joint.