Wells are 100% determined by local conditions. In the pacific northwest you will hit water very quickly and find lots of it. Arsenic and other contaminants are an issue, but if you follow the health codes most people find perfectly good water strait out of the ground without treatment or even filtration. Whether your water is hard or soft depends on the nature of the rock your are drilling though. Most off grid houses these days opt for large holding tanks and a relatively small pump. There are some great well pumps specifically designed to run directly off of solar. No batteries or inverters required.
I can recommend these pumps. I know of a couple that have been running for 10+ years off of solar without any issues.
https://product-selection.grundfos.com/ca/products/sqflex
Find the local authority and get the water tested properly. And it doesn't hurt to "shock" your system with a bucket of bleach every few months.