Perth councillors call for long-term plan to combat flooding in face of climate emergency