Civic body has identified the northern bank of the canal, near Stony Bridge and Periyar Nagar, as highly vulnerable to flooding; residents say rainwater entered their houses to a depth of about two feet and remained there for two days during previous monsoons