There are tons of things for tourists in San Diego. It really depends on what your family is interested in.
There is Knott's Soak City water park in Chula Vista, just south of San Diego, that might be a good option for July. Also Belmont Park at Mission Bay, right near SeaWorld.
Where will you be staying?