I had a sound much like this on a Dodge Daytona I used to have and it turned out to be the pulley on the automatic tensioner for the serpentine belt. drove me nuts until I found it and sprayed lube behind and into bearing area. Probably should have replaced it as it came back over time. Just a shot in the dark!

Water pumps can make a sort of ticking sound when they are going bad too.