Clive Davis: Whitney Houston made ‘valiant attempt’ to give up drugs before death