One of the best, in my opinion, would be Venice. This would cover everything, from the small, busy canals (and fantastic buildings) to the more open waters of the lagoon and from there out to sea.
Imagine using the speedboat for James Bond type fast chases through the canals - now that would be a tough mission!