When you say you are gone every weekend, exactly when do you leave and when do you return? If it means that you have to miss a single day's (or even two's) misting, it's probably not a big deal if there is a moisture source in the terrarium.

As for the pump, I don't really know. If it were me I would start by doing a search on google for 50 psi and water pump.