A very cheerful Kate Middleton didn't let the rain dampen her spirits as she visited Wimbledon