Looking for a European summer holiday in August for me, DH and 5 yr old. I would like to stay in an apartment for a week with access to a water park suitable for 5 yr olds, sandy beach and an old town to visit. Any recommendations of places I can look at? Specific towns would be even better!