Well, Rob Ford was Mayor of Toronto so it could happen!

This actually surprised me because I consider Canadians our more level-headed neighbors. I guess there are bad apples in every government.
"Ford’s time as mayor, however, was plagued by scandal.

In May 2013 a
video surfaced that appeared to show Ford smoking crack cocaine.
Ford denied any wrongdoing and ignored those calling for his resignation.
“I do not use crack cocaine, nor am I an addict of crack cocaine,” he said at a news conference.
But as more videos surfaced showing Ford in compromising circumstances, the scrutiny became more intense, and his relationship with the City Council became more acrimonious.
‘My drunken stupors’
Months later, the admission finally came: He told reporters he “probably” smoked the drug at some point.
“Yes, I have smoked crack cocaine,” he said. “Am I an addict? No. Have I tried it? Probably in one of my drunken stupors.”
The situation unfolded like a piece of surreal, tragic comedy – and proved to be perfect fodder for late night TV and comedians around the world.
Ford refused to step aside, even after the City Council
stripped him of most of his powers.
He launched a re-election bid and then spent two months in rehab, after which he returned to campaigning. But he had to abandon his re-election bid in September 2014 after being diagnosed with a
malignant liposarcoma, a rare and aggressive cancer that doctors said spread from the fatty tissue of his abdomen to other parts of his body.
Ford was instead
elected councilor for the seat he previously held, Ward 2 – his birthplace of Etobicoke North.
His brother, Doug Ford, who ran for Ford’s old job as mayor, lost.
https://www.cnn.com/2016/03/22/us/rob-ford-dies/index.html