I've read on some textbooks that it is the reaction to the force that tires exert on the ground as a result of the drive torque on the axle.
Yes, that's correct. Forces occur in pairs. If you push on a wall, then the wall feels a force from you and you feel a force from the wall. If you have no other (horizontal) forces acting on you (perhaps you're standing on ice), then that force will cause you to accelerate.
The same happens with the tire and the car. The torque from the axle creates a turning tendency. This creates a force on the ground. The tire pushes the ground in one direction and the ground pushes back in the other direction. If this force is strong enough, the car moves. (Just as if your push on the wall is strong enough, you will move away from the wall).
Many others say it comes from static friction preventing relative motion.
Friction is the method that couples the tire and the ground together. If friction is removed (car on ice), then the torque from the axle only spins the wheel. There's no overall motion of the vehicle. With friction present, the force pair between the tire and the ground appears.
For me, if the force exerted on the tire by the ground is in the direction of motion, static friction will point backwards, opposing the eventual relative motion
If you gun the engine and the tire spins (or if you're on ice or something with minimal friction), it spins in a way where the bottom of the wheel moves backward (to the rear of the car) and the top of the wheel moves forward.
Friction creates forces that oppose relative motion. Since the wheel "wants" to move backward, that means that the friction force (on the tire) points forward. The relative motion we are talking about isn't between the car and the ground, it's between the bottom of the tire and the ground.