A stretch of the Slieve Bloom river fails even minimal legal standards but other magnificent parts offer a glimpse of what could be