Deflectable guiding sheaths for use with medical catheters, fixed guiding sheaths for use with medical catheters; transseptal needles