A complete stab in the dark, but I had this scenario recently...
Just check you don't have a fast drip/slow trickle on a tap when the noise is occurring. I had a customer who had the same problem and I found a 1/4 turn lever tap had a very loose gland. This was allowing the tap to open the slightest amount creating the same noise you describe when the pressure increased during low demand times.
I appreciate this is an unlikely scenario but considering all the excellent suggestions you've had, this was something just worth checking.
Carl
Just check you don't have a fast drip/slow trickle on a tap when the noise is occurring. I had a customer who had the same problem and I found a 1/4 turn lever tap had a very loose gland. This was allowing the tap to open the slightest amount creating the same noise you describe when the pressure increased during low demand times.
I appreciate this is an unlikely scenario but considering all the excellent suggestions you've had, this was something just worth checking.
Carl