Legend has it that anyone who sips from a 145-year-old public drinking fountain in Providence is destined to return to the city.