I would probably try the yarn first before the hot melt; maybe even some lead tape would help?
When I worked with ultrasonics we would use a type of epoxy or hot melt with tungsten to dampen vibration and sound, but I never tried it to change the sound of a golf club.