More than £1 million will be spent upgrading a three-mile stretch of the Birmingham Canal in Sandwell, council chiefs have revealed.