Daytrippers are invariably drawn to water, and in North Wales there are two in-land sites that are more popular than most