Corrie star issues 'goodbye' message as fans 'sob their heart out'