Leaders do not motivate per se. They create conditions for people to motivate themselves. They do it by communicating clearly, setting clear expectations, following through and recognizing performance.
You are only afraid if you are not in harmony with yourself. People are afraid because they have never owned up to themselves.