Cooling off at a splash pad is a great way to reset when your summer vacation takes a hot and grumpy turn. These five U.S. cities offer great options.