Sports clubs and members of the community came together to pay tribute to a little boy, eight, who died after being shot in the head on a farm near Yorkshire.