With unique views, fascinating history and opportunities for wildlife-spotting, taking a small boat across a river or to an island can be a holiday highlight