Forget the beach, try these lakeside destinations instead.