How long does a card hold take to drop off?

Two to five business days, and it is the guest's bank that decides, not the venue. Local banks and credit unions on older systems sit at the slow end. On a credit card the hold only shows as pending; on a debit card the money is genuinely out of reach until it clears.