Residents hope years of sewage problems could soon come to an end after a water firm announced major works.