Text this: A Resilient Solution for Sewer Overflow Monitoring across Cloud and Edge