Nolan Neal's cousin Dylan Seals confirmed to PEOPLE that the late musician "ultimately succumbed to his battle with substance abuse"
