I tried heat tape on the line from my well to the water pump maybe ten years ago. Mixed results, until I wrapped the line in light insulation.

Then I heard news stories about heat tape fires (involving rated heat tape, properly installed) so I unplugged it. Surprise surprise, the insulated line didn't freeze. Seems like the small amount of heat in the water I bring up is enough to keep the line open. (I did have to heavily insulate the thin pressure tube that leads to the pressure switch; that was the first point of trouble.)

Again, keep in mind the "fire stories" are at least a decade old. Hopefully standards/construction have improved.

But if you can use insulation and ground heat energy, that's the simplest and cheapest route.