Sounds like detonation (also known as pinging or pre-ignition) to me, but these things are so hard to try and diagnose over the internet. Has the car got good fuel in it (at least 95 RON premium unleaded)?

Does the sound go away at a different RPM or if you put your foot down more? Are you in 1st or 2nd gear when trying to make this noise occur?