Hello again. Where to start lol.
Given your present situation, I really think you will benefit from this op.
I think it is good they are leaving your bladder in, it spares very likely nerve damage resulting in no sexual feelings below, amongst other likely issues that they choose not to tell you about.
Hospital stay varies, 7/10+ days. Once you get used to the stoma, life should improve a lot for you, as you will find on here, people try to live pretty much normal lives, everyone is different but without the op many would not be here at all.
Ask your hospital urology to speak to someone, stoma nurse at least, often a person with a urostomy will call or visit you and talk to you about it.
The Welland Aura one-piece bags suit Sue's skin but you will probably try a few different bags until you find the best for you, that sticks well, comfort etc.
Don't be afraid to try different types and do expect failures, knowing they are part of a learning curve, try not to let them get you down.
Sue's worst was 5 fails in one day, it was down to a bad batch, it can happen, as I am sure many on here can attest to.
Keep your night bag in a bowl or something similar, night bags can also leak and do.
I will not tell you how to fit them as plenty of advice is on this site and others, anyway, you will adapt your method to suit yourself along the way.
But ... warm the bag before fitting and know that a tiny dribble of urine just as you are putting it on will cause the bag to fail shortly, you must be dry.
Always have an emergency kit wherever you go, spare bags, wipes etc. It will fail one day, just be prepared.
Be aware that about 50% of stoma patients will end up with a hernia, do some research on this, prevention, early signs etc. Talk to your stoma nurse.
Will your husband be supportive/proactive?
Now would be a good time to order free samples from the many companies on the net (type in urostomy samples), bags 1 & 2 piece, night bags, leg bag, glue remover pads, barrier wipes - these leave a thin protective barrier on your skin around the stoma as urine can/will irritate your skin, stomahesive paste - like toothpaste to form a better seal around your stoma, mattress protectors etc.
Spend a lot of time researching everything about urostomies, bags/types, fitting advice, possible problems etc. Forewarned is forearmed!
Try to get the number of the post-op stoma nurse who will visit you at home, they have more time for you, they are very helpful and are dealing with stomas daily, better than most GPs for information, Sue's GP thought hers was a colostomy and district nurse didn't know the difference!
Keep in mind that urostomy supplies are big business, I know the NHS pay the tab but you are the customer, supply companies want your business and nothing should be too much trouble if you ask for something.
I may appear to be a bit negative but I'm not, just giving you an idea of what to expect.
Is there anything specific you want to know or ask about?
Steve