Fentanyl, alprazolam, codeine, promethazine, and THC were found in the artist’s system, according to the Fulton County Medical Examiner