what is the best solid color water based strain

I would look at Flood's Solid Color Stains

Do the Flood stains also waterproof? Should water bead up when it rains?

Beading water is a myth and not needed. You do not want the wood to be 100% sealed as that can create issues down the road.