Interesting. My climbing gym accepts credit cards. It also allows me to cancel or freeze my membership online, though.
If I were in that situation, I suppose I would open a new account just for that purpose, turn off overdraft, and transfer money into the account as needed.