I ordered a hand-held massage one through my electric utility. Seems fine, Waterpick brand. In addition to the massage/not option, it has a soap-up valve that reduces flow to a trickle to save water when you want to do that.
For your situation, get a couple of low-flow heads and also a twist-handle shut off valve, available most hardware stores. Put it between the head and neck of the side you want to shut off, and you'll be good.