I have a couple of working windmills on the property. Mine are Flint & Walling brand. Star 26 and Star Zephyr out in the fields. You should check the local Craigslist cities in your area to find one that's 4 sale all ready to go. A 30' tower with an 8' fan and a couple of brands in working condition go for about $1000 to $2000 around here. Brand new will be $1000 more. All kinds of pumps and cylinders are available, too, both new and used on eBay. Its no big deal to put up a tower over an existing well using a tractor. Adding the motor and fan is pretty straight forward as long as you are not afraid of heights. Get the well checked out first to make sure its sanitary and has the volume capability. Be on the lookout for a pump jack that allows you to cycle the pump with a hit/miss engine. Then the Cool Factor is HUGE !
The clone of Frank Lloyd Wright's "Romeo & Juliet" windmill (last picture), has a tank built right into the tower. That would give you water pressure in the house if that's a requirement.
Getting an older one from the '20s or '30s and fixing it up will give you a lot of pride and satisfaction. Parts are available or can be made in-house using simple tools.
Although the flow rate is not high, a 2" cylinder with a 4" stroke can produce a lot of water over a 24 hour period in a mild wind.