I too am relieved nobody said it's a leak because our house that we moved into like 3 years ago has a very similar tapping noise, happens when we shower and sometimes with our sinks. I haven't seen any water damage in all this time, so was hoping it was just thermal expansion. Definitely not water hammer, that's pretty distinctive sounding and really only happens right when the water is turned on.