Sure! Yell like a champ!
I was in the Navy for many years, as a nuclear reactor officer. Needless to day, yelling is more or less a professional obligation in the Navy. I yelled all the time; I loved yelling and was good at it. I think yelling is normal, so to answer that part of your question, I'm going to explain how it can be effective.
Don't yell at individuals in public
Yelling at people in public is humiliating, especially if you are their boss and they are your subordinate. Now, if you are a drill instructor, humiliation is kind of the point. But even in the regular military (and I was an enlisted Marine, as well) yelling at people in public is counter productive. That is not useful or professional.
In the military, peer to peer yelling is the most dangerous kind, since that usually escalates to peer to peer punching. As a leader, don't tolerate that with your subordinates, and do not, do not engage in that with your peers (especially as an officer). Conflict among leaders erodes trust in leadership.
Yell at groups in public
If everyone messed up as a team, then they aren't really being a good team. Nothing builds a team like shared adversity. What better way to get them to share adversity than to yell at them? This method works well with some sort of shared discomfort, something that forces them to all be together suffering, like shining all the brass fittings in the engine room for 2 hours one evening. Just make sure that the depressing shared punishments are balanced against shared accomplishments and shared rewards. Again, do not underestimate the team-building value of shared adversity.
Yell to keep people awake
Do you do training? They sure love them some training in the Navy. As everyone knows, training is boring as all get out. If you have to sit through the training, you are probably planning on falling asleep. From the training-giver's perspective, that is non-optimal. Training is boring, but you often want people to at least pay semi-attention and hope that something sticks (you know, like what do do when the ship is sinking, etc).
The solution is, of course, yelling. Don't speak your training, yell your training. It is harder to fall asleep when someone is yelling at you, and enthusiasm tends to be contagious. Note, that this actually take a lot of practice. You have to know what you are going to say before you start yelling or you ending raving in gibberish. I would run through an hour long training in the mirror at least once before giving it, and keep index cards in hand. You can't go up and spout gibberish, lunacy is just as contagious as enthusiasm.
Yell for motivation
Lets say you've progressed beyond save-the-ship training and gotten to save-the-ship practical application. Your minions, to save the ship, must get together in a team of six, drag a charged firehose down a 30 foot metal ladder into a (simulated) raging inferno while wearing firefighting gear and breathing tanks. Now you are practicing this in the Persian Gulf in the middle of summer, and the (simulated) fire is in the 115 F engine room.
No one is excited about that. Do you know how much you sweat in a facemask when it is 115 F? A lot, like more than Patrick Ewing. I've seen people sweat through a firefighters jacket in under an hour. But you know what gets people motivated? Some yelling! Yell encouragement! Yell profanities! Yell some stories about people who won a Navy Cross in WWII fighting fires (again: requires preparation).
Every once and a while, yell at someone in private
This is another dangerous kind of yelling. You want to develop trust in your leadership with everything you do. There are three markers that indicate the situation might be right for a private yelling.
First, only yell if the person has done something with vast potential negative consequences. Broke something that keeps the aircraft carrier from launching airplanes? Congratulations, Petty Officer, the President of the United States is literally going to be briefed about your shortcomings. Did something that jeopardizes reactor safety? You better get your yell in, because you know the Captain is going to be yelling at you soon, and people might start losing their jobs. Instill in the recipient a healthy fear of what could have gone wrong.
Second, you have to know what you are going to yell about (sensing a trend?). If you just go spouting, you will yell something that doesn't make sense, and your victim will be moved from fear to contempt.
Lastly, do not yell at someone that doesn't care. Yellings are reserved for those for whom you have respect. If the person is a dirtbag, yelling is just a waste of your breath. Write them up a formal counseling and hope they get drunk at the next port so you can kick them out of your division.
Ultimately, an occasional private yelling reminds your better workers that a. you care, and b. they should care too.
Yelling is perfectly normal and professional if done right. I'm a database architect now, so my human interaction is mostly restricted to sneering contempt for people who ask me about the contents of the database and don't know SQL. I can honestly tell you that the part of leadership I miss the most is the opportunity to yell.
So, wear your passion on your sleeve! Give a s**t; heck give all the s**ts! Lets go warriors! Ooooraaaahhh!!!!