The author and father of four had a history of drug and alcohol abuse, according to the Travis County Medical Examiner's Office