Thank you so much for the information about the supra pubic catheter! I just googled that and it sounds like what I'm looking for (had no idea what it was called though). I can deal with a needle through my abdomen!
Interestingly, this method is apparently more hygienic than a foley catheter. Bonus points!