From hidden riverside gems to the sandy shores of water sport-friendly lakes, these lovely spots make for a great beach trip - even if you’re nowhere near the coast ...