Wait... Alliance gets quests in this patch?
As for the canals in Stormwind, they are, well, canals. Mainly used for transportation of goods, much like any set of canals in a medieval city. I do believe the sewers are mainly underground.
Pretty much like the Undercity, in fact.