Urban escapes can also be underwater adventures in these splashy summer destinations