Hi, Welcome to our site, but sorry you have to be here. Take a deep breath and try to relax. We all know how you feel, we have "been there and done that". The first thing is to have the biopsy and get the results. To answer your first question, normally you will be and out patient and sent home from recovery. Yes you will be totally out during the biopsy.
It is always good to get a second opinion, so after you have the results search for the best doctor for bladder cancer, at the best available hospital. Depending what the results of the pathology are, you and your doctor will decide the best treatment to pursue.
My brother also had bladder cancer and he is 8 years out and had a neo-bladder. He is doing great.
I had CIS and was treated with BCG and I am 5 years out.
Bladder cancer can be treated and life can go on. Keep reading all the information you can, and get that second opinion and you will be on the right track.
I am sure many more will respond your questions. Feel free to ask anything here, we will all try to help.
Nancy