A football match is to be held in honour of a Herefordshire man who died in a "horrible tragedy".