The only realistic choice for the C Dory is the Katadyn 40E. This was started as a manual powered life raft pump type of water maker. I have known several cruisers who have used them, with reasonable results. The cost is going to be in the $4300 range. That I believe is the cheapest option. Buying used --and they do come up fairly frequently for about half that--is the other option. But you may have to rebuild the unit. For crossing oceans, this may make sense. But I don't see it as viable for coastal cruising.
I have friends who have made their own 110 or 220 V AC water makers. But the size of the high pressure pump is the issue--and puts these out of class for the C Dory of any size (except perhaps the 27 with the fish hold.)
I have owned two different water makers--each was used 4 years, almost daily. The first was a Standard, 20 gallon an hour, with a 110 V AC CAT pump. The second was a Village marine (also 20 gallons an hour), but it used a commercial grade wobble plate pump. Both had pressures in the 900 PSI Range. The Wobble plate pump was far superior. It was longer lasting, had far less service issues, and was quiet. It ran at about 600 RPM, vs 3600 RPM for the CAT pump. If you could find one of the Wobble plate units, it could be run off a 12 volt DC motor--but the current draw and output would just be worth it--plus the bulk of the membranes and filters...
The care and feeding of these watermakers is important. The membranes are susceptible to oils, and bacterial / fungal infections, This means that they cannot be used in most commercial harbors. Also Chlorine will ruin the water maker membranes. The membranes must be used daily--and if not use for more than 5 days should be "Pickled". Membranes have to be replaced if damaged. Also they are susceptible to freezing damage.
I don't see any issues cruising the BC coast. There are many water sources, which can be utilized, and then a filter and UV light can be used to treat the water.
As for Baja--Our cruising in that area was on our two larger boats (62 and 46 feet, both with 8 KW generators, and at least 500 gallons of water tankage. Even then, we reserved 100 gallons just for the water maker, and never filled it with shore water. We feel that it is a good idea to back wash the membrane after each use. thus no domestic water ever was put into our water maker tank.
We did a TransPac race with 10 crew and 50 gallons of water. After 15 days, we still had some water left. I cruised the West Coast of Baja in the 60's with a Columbia Defender and only carried 20 gallons of water. We did fine for month +trips. You can get water in villages and treat as below. There are lots of fisherman who ply the coast and even oceanic Islands--they get enough water.
All cooking and bathing is with salt water. Even brushing teeth is with salt water. Fresh water is for drinking only. In the C Dory, one can put a bladder tank up forward, and should easily get 40 gallons total.
Water should be filtered against parasites as well as anti bacterial, anti fungal and anti viral treatment. Virus and cysts are the biggest issue which most systems do not address.
First you want a [1] prefilter--that removes any gross contaminates which you might see and would rapidly clog a [2] bacterial and parasite filter (down to .02 micron) [3] purifiers, which may take the form of a filter which is able to remove virus, ultra violet light, chemical treatment or boiling. The latter two are the cheapest way to go.
There are a number of particulate filters/with charcoal core to remove particles and tastes--these are used on campers etc--and can be run on gravity or with a pump, such as a pressure sprayer commonly known as "in line filters".
Probably the best bacterial and parasite filter is the Katadyn Hiker Pro Clear Microfilter. It takes about 50 strokes per liter to pump the water thru. It is also on site re-cleanable. This is in the $80 range.
For the purifier the Steri Pen, with AA batteries would be a choice for virus in addition to a pump like the Katadyn Hiker Pro. Don't believe the hype that UV will eliminate all protozoa and cysts. But using this effectively can eliminate the virus issues. The MSR Guardian Purifier ($265) uses a back flush technique and membrane is good for up to 10,000 liters. It takes about 35 strokes per liter--claims to be virus free--again, I would want to use UV to be double sure.
CDC puts out a nice table which shows the effectiveness of the various techniques..
Rolling boiling water for at least 1 minute wins hands down.
The old household bleach--one teaspoon per 5 gallons, stir well, and let set for 60 minutes works--but boiling is best.