I’ve had good experiences at courses near lakes. They tend to take care of their equipment well.
And remember, renting clubs is a great way to test new equipment without any commitment! Just don’t let them charge you an arm and a leg, unless they come with caddy service!