Any weatherproof silicon caulk will do. I just did this to my pool and went with a clear weatherproof caulk. The color choice is up to you. One thing I would recommend is to add backer rod before reapplying the new caulk. I got 3/8" thick foam backer rod. This can be found at Home Depot, Lowes, and most pool stores. It gives the caulking something to adhere to and fills the gap which is typically too large to fully caulk.
Lastly, some people opt to sprinkle fine sand on the caulking before it cures. This does makes it blend into the cement (tile in your case) a little better.
Good luck!