As long as you know the rules I don't imagine you making a fool of yourself.
I guess there are a few tourney specific rules. If you touch a piece you have to move it (if it has a legal move). If you touch an opponent's piece you have to capture it (if you can). So don't move until you're sure about your move.
Do you have to keep score i.e. write the moves down? If so be sure you're familiar with how to do that I guess. Hit the clock after every move. If you're unsure about a rule or something your opponent's done during the game stop the clock and find a/the tournament director and ask.
I've never had a problem with an opponent though. You basically show up and play chess. You do move, push clock, write it down, in that order. "sit on your hands" (don't make impulsive moves) and of course have fun :)
I'm entering a chess tournament nearby tomorrow evening. I read the details a couple of weeks ago, and I believe they said there will be two tournaments at the same time, one for people rated under 1k, and one for 1000 to 1600, and in both, the clocks will be set to thirty minutes. Since I have no official rating, I assume I'll be in the former?
I honestly know pretty much nothing about chess tournaments except from what I've seen in YouTube videos and such.
Can anyone give me any tips to help me avoid making a fool of myself?