A man has died after entering the tiger enclosure at an animal attraction in Yorkshire, according to police.