I think that Dumbledore is gone and won't ever lead another song. His portrait will be in the Headmaster's office because that's the tradition and they wouldn't break it.