The Hollyoaks and Celebrity Big Brother star had a history of cocaine use