The wave frequency and energy of traditional piezoelectric emission sources used in acoustic logging are limited, which results in an inadequate detection resolution for measuring small-scale geological formations. Additionally, the propagation of these waves in formations is prone to loss and noise interference, restricting detection to only a few tens of meters around the well. This paper investigates an impulse sound source, a new emission source that can effectively enhance the frequency range and wave energy of traditional sources by generating excitation waves through high-voltage discharges in a fluid-penetrated electrode structure. Firstly, a high-voltage circuit experimental system for the impulse sound source was constructed, and the discharge and response characteristics were experimentally analyzed. Then, four types of needle series electrode structure models were developed to investigate and compare the effects of different electrode structures on the impulse sound source, with the needle-ring electrode demonstrating superior performance. Finally, the needle-ring electrode structure was optimized to develop a ball-tipped needle-ring electrode, which is more suitable for acoustic logging. The results show that the electrode structure directly influences the discharge characteristics of the impulse sound source. After comparison and optimization, the final ball-tipped needle-ring electrode exhibited a broader frequency range—from zero to several hundred thousand Hz—while maintaining a high acoustic amplitude. It has the capability to detect geological areas beyond 100 m and is effective for evaluating micro-fractures and small fracture blocks near wells that require high detection accuracy. This is of significant importance in oil, gas, new energy, and other drilling fields.