That’s great news!
You can find Durapore tape on Amazon, it’s the only tape I found that would hold well. It’s the same tape that the hospitals use in the operating rooms.
It might be uncomfortable for a few days when you pee, but it’ll improve quickly. Also, your bladder shrinks a bit and becomes sensitive to stretching when you have a catheter for any decent amount of time. How often you have to go should return to normal within a few weeks.