The soap will tackle a rare but powerful diagnosis for one of Weatherfield's favourite characters