If you're going to Disneyland, the cards with the pirate quest questions are in the stands at the VMK booth, in Tomorrowland. (During bad weather, this booth is closed but the the VMK stuff gets moved inside Innoventions.)
The card with the code for the well is actually attached to the pirate quest card. It is not necessary to do the quest in order to receive the well, and they don't seem to mind if you take more than one card from the stands. However, only one quest per guest may be turned in to receive the card with the room code.