The longtime host and executive producer of the long-running interview series will hand over the reins to a rotating list of guest hosts as the show moves from Bravo to Ovation TV.