In my area there is very little as far as grounds /water for training. and I am about 2 hours minimum from any events/clubs. Firehouse has given good advise on MO dog country. Plus the Missouri river is a major flyway for ducks. Lots of hunting public and private on that side of the sate,and not to far from the "golden triangle" for ducks.
The center of the state around Columbia is a nice area,nice town and basically somewhere in the middle of KC and St. Louis.