Not a direct answer to your question, but my mid-day shot opportunities have had nothing to do with a particular water source. They had everything to do with hunting where I either knew or suspected they had bedded for the day. If there's a hot cow in the herd, you should be able to get the bull talking and make a play on him, no matter the time of day. I have also had success getting them to stand up and come check me out silently when they aren't all worked up over a hot cow.
If I was going to set up over water mid-day, I would figure out where they have been bedding, find a heavily travelled game trail that leads to a nearby wallow or spring, and figure out what the thermals tend to do from 10-4ish. Set up your stand or blind accordingly.