Sue Cleaver recently announced her plans to wave goodbye to Weatherfield after 25 years in the iconic role