As spyder said the ground rod and the water pipe are seperate issues. There is no requirement on where you locate the ground rod as long as it is installed correctly wired correctly and in a suitable location. It could be by the panel and usually is around here.
Where the water pipe comes in is a different subject.
