The wall was built as part of efforts to safeguard 6,000 properties from flooding. 'Must be a lot of relieved homeowners', said one observer