Wondering about water systems for small farm

Hey all !! Wanted to get some input on what people were using for filtering their water. Im in the planning phase and want to get my ducks in a row before I start up. Im looking at probably 100lbs-200lbs medicinals a week ultimately. Ive heard/read R/O is the way to go. But wondering your thoughts. Any tips, hacks or ways to DIY it would be appreciated. Thanks !!