What do people expect from their leaders ?

The Peter principle states that people in a hierarchy tend to rise to their "level of incompetence". What makes a good leader, what do people expect from their leaders, and what qualities does a security leader need to have?