Actually, I would respect them a heck of a lot less if they had ever smoke marijuana. It shows a complete lack of intelligence and moral judgement. However, I could live with it so long as they wizened up and dropped the drug.
If, on the other hand, they were still sneaking drags I would have absolutely no respect for them at all and would consider them supremely unqualified for the role of leader.