The family of a man who shot himself days after his first experience with a magic mushrooms-type drug has issued a stark warning about the dangers of drugs.