For a residential water pumping, #6 to #14 AWG range wire will do the job. For a large pump for commercial use, people use 500 MCM size of wire also.