The producer will be remembered as a "young man full of life," his family said in a statement to PEOPLE