A fatal combination of alcohol along with legal and illegal drugs took the guitarist’s life while he was on a leave of absence from the band