A top tourist attraction near Sheffield has issued a statement after visitors destroyed property, left rubbish “all over” and were aggressive to staff.