Ex-Harrogate solicitor struggled with alcohol dependency, inquest hears