I worked for a mid-sized city in Western NY state. The city was the AHJ and therefore I was such. I believe that the question of utilizing the incoming water electrode being used as a GEC came about with the 2014 code cycle. In the city I worked within, there was a program that replaced all the metal water pipe in the streets up to the premises property line where the shut off valve was located. That often left it up to interpretation whether the electrode remained intact for 10 feet as many city lots did not have 10 feet of land between their foundation and the city's property line. At that time, most outside inspection agencies and the city agreed that we would no longer accept the incoming water line as the primary GEC. Double ground rods spaced 6-feet apart became the norm on a service change in old construction. In new construction, bonding of the footer was required which became the primary GEC with a ground rod driven as supplemental. If memory serves me correctly, I believe it is 250.52(A)(1) that defines whether a metal underground water pipe is to be used as a grounding electrode. The last code cycle I enforced was 2017. It should be the same for 2020 but I do not have access to that edition. And of course, for all the technicality people out there, the AHJ enforces the International Code. You can get to the NEC from there but technically, you can't quote the NEC in enforcement. You have to quote the IRC for residential of the current code cycle. I believe that the IBC refers you directly to the NEC if I recall. Things may have changed since I retired.