Ours comes in an ancient pot pipe from who knows where, into a brick holding 'tank',gravity fed to the house, overflow from the tank runs into stone trough, overflow from that feeds a trough next to the house.
All OK, but in dry weather we can't use much water or there is none for the cattle.
When we were building the barn, lot of underground water so we put drainage pipes in, built another tank, that carried on running when the top one almost dried up in a hot summer., just boiled it well ?.
No testing officially required for 1 private household, but after I was VERY ill when idiot neighbour broke the supply pipe, but we now have a filter and UV system.