Water levels ‘nearing the brim’ as sea level rise brings higher tides