Venice's grand canalscapes make it a great place to dream, says Nick Trend.