To put in the catheter, your medical team probably won’t put you to sleep, but they will give you medicine to relax you and make you sleepy. And they’ll numb the area where they’ll put the catheter in.
There’s a related kind of catheter called a peripherally inserted central catheter (PICC). It goes in near your elbow and runs up through a vein in your arm.