An eight-year-old boy has died after he suffered firearm injuries to his head and face at a farm in Cumbria.