Well then, the sites closer to the 174 end would be better.  You'd have to walk all the way to the end of the loop to get to the beach area.  And at the 174 end, the water is just barely viewable from the sites, and the tent sites are between you and the water, plus it is heavier wooded at that end between you and the water.  Have fun!