Investigators say they found a man dead inside his South Carolina home shortly after finding an item from a missing 6-year-old girl inside his trash can