Authorities say the former One Direction member was going through an “outbreak from substance abuse” before his death