I wouldn't call it a set rotation, but there is a list of cities/venues that the game is assigned to, more frequently than others. New Orleans, Santa Clara, Los Angeles, Houston, Phoenix, Miami and Tampa.
Las Vegas will join that list as well.
Atlanta will host it's 4th Superbowl, coinciding with their newer stadium opening, and I would not be surprised if they become a more frequent host now.
Jacksonville has had 1 game, and while they did not have the required hotel space, they docked cruise ships in the port to serve as floating hotels. The league has not awarded them with another game as it was not an ideal solution.
Dallas was awarded the game when they opened their new stadium and suffered an ice storm and some logistical/infrastructure problems and the game has not returned.