Go to one of the prettiest cities in the country (OK, I'm biased) - Sarasota, FL.
Cultural sites galore for the family, SW fishing around every corner. Sarasota Bay, other waters are easy to access and kayak rentals will put you where you want to go at a reasonable price. Snook fishing on the beaches is free. There are no bad areas of Sarasota Bay. Rentals in summer are cheap, cheap!
Take 7 or 8 wt rods, sink tip lines in Types I and III and Clousers in 1's and 2's. Something neutrally buoyant for the snook in close to the sand.