A system for providing medical electrical stimulation including a lead assembly and a cannula. The lead assembly includes a lead body and a needle tip. The lead body has a distal section and a proximal section. The needle tip is formed of an electrically conductive material and is connected to the distal section of the lead body. The lead body is slidably disposed within a cannula lumen, with a distal end of the cannula being selectively connected to an abutment surface of the needle tip such that the needle tip extends distal the cannula to define a needle probe. With this construction, the lead assembly can be delivered to a desired implantation site via manipulation of the cannula and/or energization of the needle tip, and the cannula can be removed from the lead body without requiring movement of the needle tip.