From the RM blog archives is this picture taken in February of 2009:
The old sign
It was just a pole with a blue wavy level indicator to let you know that that was one hell of a flood some 15 years ago.
Duncan Madog and the Black Sheep resting on the new sculpture
The grade school style water sign has been replaced with a more artistic and pleasing version (although I though it was a flying goose at first) and the pole is now a buffed stainless steel pyramidal spire with teardrops punched into the steel at regular intervals. And there is more: In addition to the top most water level are three more for comparison. The first level (right under the bike saddle) indicates a 10 year flood. The other two represent a 50 and 100 year flood. You gotta go up another 7 feet to see the top: