Death of Harrogate man, 45, was due to drugs, inquest hears