A visitor tragically died after an incident in the grounds of a popular visitor attraction near Sheffield.