Hello and welcome!
The majority of us on here have ileostomies or colostomies, not urostomies, but we are definitely here to help!
Everyone is scared before surgery but 95% of us are so very happy to have had the surgery so we can get on with our lives!! Having an ostomy doesn't mean giving anything up...it allows you to live your life!
I go to a support group in my area and there are a few people with urostomies. It's really not the end of your life, I promise!
As for what pouches to get, just try different things until you find what works for you...everyone is different, so it's hard for us to tell you what would be best. We can answer any questions you may have though!!
Again, welcome, and seriously, it's a major surgery, but we all came out on the other side and you will too :) There are better days ahead!