It stops when I turn on any tap in the house (Hot or cold) or flush the toilet. The noise starts at random at any time, then stops and starts randomly. Until I turn on a tap then it goes quiet for a few minutes. Any ideas?

Could be a bad pressure regulator. Turning on the water reduces the pressure until it builds up again. Sometimes a leaking toilet fill valve will do that. Turn off the water to each toilet and see if it stops the noise.

Do as Ma0641 says, Also get a water pressre test gauge see the image and check your water pressure, Thanks.

John

Thanks for the support
It is a faulty ball valve in the toilet cistern.

Water seeps past until it gets to a certain level then...
The noise resonates through the pipes

Now to fix it. At least I have not had to do each tap washer one by one as a process of elimnination

Glade you found the problem, Thanks form the update. It helps us tom answer other questions, Cheers, Tom

Thanks for the update.

John