Cliff Drive is not a bad place in the that side of the city.....statistically speaking Westport has a much higher crime rate, but to each their own. It is often patrolled with police, and in general pretty safe to play. You have to be cognizant of the environment, but that is with any public park that you go to. Waterworks is not as sparsely populated as some may lead you to believe, it has quite the foot traffic as well, though surely not as much as Rosedale.
What ever choice you make, playing all the courses and having fun is the most important thing to remember.