Hello Paul, the catheter experience for me was a non event, it was a nuisance ,no pain, just in the way, especially when having a bath. If you have a shower in your home then it would be much easier to wash.
Going out was fine, the catheter is strapped to your leg just keep an eye on the level, you would need to empty it quite often though, and at night you use a bigger catheter on a little stand and empty it in the morning. The catheter was strapped to my left leg and sleeping on the left side of the bed it was easier at night, be careful, try to sleep on your back or side otherwise you could kink the pipe and stop the flow of urine into the bag.
I had no pain only iritation only where the catheter entered the penis, however keep this clean , when I had a bath at night I made sure I washed the entry point with cotton buds with simple soap.
Hope this is reassuring and calms your fears.
James