Being a super, I can say that moving the tees daily, within a few yards within the confines of the dedicated tee box is normal, mainly to prevent excessive wear and tear. Moving a particular set of tees with greater variety can present some problems. Rating is one of them....as Tom stated, more than 25 yards and you're technically not playing a rated course. Another, more for publics, is that it may confuse golfers trying to find markers that aren't on or near their dedicated teeing area. Also, golfer percpetion....it may be fun to move the back markers up with the forward markers to make the hole play differently, but the majority of your men will complain that they don't need to hit from the "ladies' " tees. While sometimes for special tournaments or by request the pro and super may manipulate the teeing set-up, the easiest way to experience variety is to do it yourself.......break away from the path dictated for you and play how you want, for your own enjoyment. There is no law that says you have to play one set of markers, unless you are truly anal about posting a legitimately rated round every time you play. So here are some good options I've seen:
Red, White, and Blue - This one occurs on a course with red, white and blue markers. Choose to play six of each. On a regular round, it will cause you to rethink some holes, but even more fun is to try a member's tournament in this fashion, with teams. It's interesting to see teams stratagize before the round as to which holes they should play from which tees to try and maximize their advantage (i.e. be able to drive over hazards, reach par 5s in two more easily, drive a green on a par 4)
U.S. Open Day or "Monster" Course: This works more easily at privates, but I'm going to try and push for it even at my public here. The idea is near the US Open (it can be anytime really), when people are all fired up about seeing how difficult they'll make it for the pros, have the super and pro work together to set up a set of tees to stretch and tweak the course to as difficult as it can get. At a private I used to work at, they would sometimes move the back blocks to a nearby tee box of a different hole to lengthen it or change the angle, provided there was still a legitimate route to play the hole. This course set-up should also be manipulate in conjuction with difficult or tough tee placements......like pushing the pin far right on the green where a tree hangs over and putting the tees on the far right as well to bring the tree more into play.
Mixed Tee Rating - This is becoming more popular with mainly senior golfers on courses that have limited space to not be able to add new tees. It's been mentioned above but it's mainly making a combo of back tees and regular tees usually, getting it rated and putting it on the scorecard (or making a completely new scorecard for it). I've actually seen some high end privates that have made like 5 or 6 options for members varying across all tees, all rated and with their own scorecards to help them enjoy the course in ways I've mentioned already while still being able to legitimately compete with handicaps.
Lastly, simply play from a different, preferably more forward, set of tees. It may feel demeaning or that you're making things easier on yourself, but trust me, it doesn't always work that way. I just recently played the regular tees on a course I've ALWAYS played the back tees, and I literally had to rethink EVERY hole. The more forward tees changed my teeing club selection on at least half the holes, brought more hazards into play that weren't there before, took driver out of my hand and made me play more exacting layup shots and enabled me to reach longer holes that I had rarely been able to reach before. Not all courses will be like that, but kudos to the architect who can pull it off. It definetely reinvigorated my enjoyment of that course and I'll be back to play from those tees again soon. BTW.....my score wasn't any lower from playing those forward tees.....does that make me a crappy golfer?