A former MP who resigned after facing allegations of sexual misconduct and cocaine use has died aged 59.