My car had self adjusting tappets and made the same sound on startup and when giving accel.
Changed the oil to fully synthetic thick oil and sound was gone.
If its water body you would hear a rumble instead of the noise you mention. If you want to be sure its not water body , get the fan belt removed and rev the engine