When the hot tap is running and the noise is present nip up into the loft and push the float fully down see if it stops the noise, and then lift it up fully

If either of these actions stop the noise This and the fact that a cold water tap turned on stops the noise proves that it is on the cold mains side of the system. It can only be one of two things, the ball valve or the main stoptap.
If you think about it, these are the only parts that move that will have running water passing them under pressure. Another trick is to open the main stoptap fully against the stop.

The anomaly is that it doesn't happen with the sink and basin taps, this could be due to less volume of water being drawn through the domestic hot water tank, may be worth turning basin and sink tap on to see if it happens then
