A Rhode Island city councilman seen on police body camera video getting arrested for drug possession has stepped down from his seat after he was caught asleep behind the wheel with a crack pipe in his hand.