A catheter and method for managing fluid in a patient, the catheter having an elongated shaft with a distal end and a proximal end. The shaft defines at least one lumen extending substantially therethrough, the shaft further defining a plurality of drainage holes along a distal portion of the shaft, with the drainage holes in fluid communication with the lumen. The catheter further has a substantially transparent tip portion attached to the distal end of the shaft with an outer distal leading surface that is substantially rounded to assist insertion through tissue.