Tributes started pouring in for the heavy metal pioneer in the moments after his family announced his death