The former Tory deputy prime minister, an ally of Boris Johnson, resigned in the wake of a probe into his behaviour