Permanent catheter with dementia

I’m a caregiver for my mother. She has early onset dementia that she’s had for about 10 years. She does fairly but has a lot of other health issues. One of those being she has issues with her bladder. Her urologist is wanting to put in a catheter that would stay in all the time. I’ve never had any experience with a catheter and I’m not sure what to expect for her. Her neurologist states this could make her dementia worse or for her. But in a lot of ways, we won’t have a choice she will eventually have to do this. I’m just looking for on how to handle this how hard this could be and how to make it easier for her. I want my mom to have the best life she can and the best quality she can for as long as possible, and I’m scared the catheter will take a lot of that away. On top of the dementia and the bladder issues, she has other health issues that make life hard for her. She’s bad knees, kidney issues, and a few other health concerns that just complicate the matter. She never complains and always stays in good spirits. We are blessed with how well she does and how well she’s handled everything. I’m just afraid this will be the tip of the iceberg for her and me. Thank you.