The pump you listed is much better than a sump pump, but I like the small 2-cycle water pump Harbor Freight has similar to this http://www.harborfreight.com/1-1-2-half-inch-clear-water-pump-with-25-hp-ohv-gas-engine-98013.html

You can use adaptors to use the cheap plastic sump pump hose with it.

(The 2-cycle pump is very light weight and has a 1 inch inlet/outlet)

In this case, FLOW is not nearly as important as pressure. You need pressure to get both distance and to get a good spray pattern.