For dry sand (and sometimes wet if enough water is around to wash it through) I use a homemade scoop. I bought a plastic 3-quart feed scoop at a local tack-and-feed store, drilled lots of 3/8" holes in it, and voila, a great scoop for around $5.00. Works as well as one of those $30.00 ones available on the 'net. Of course, it involves a lot of bending and kneeling, but hey -- that's good exercise, no?
If you are working in the water, I'd suggest buy a well built, all metal/welded unit. But for my coinshooting on the beach, what I have works great!