When it comes to water sports, San Juan [1] pales in comparison to the rest of Puerto Rico [2], but there are many tour operators in the area that will provide transportation to nearby sweet spots for snorkeling, diving, fishing, and more.
Links:
[1] http://www.moon.com/destinations/puerto-rico/san-juan
[2] http://www.moon.com/destinations/puerto-rico