The "Vanderpump Rules" icon will inhabit the role of Connie Francis from Sept. 12 through Nov. 22.