What are the repercussions of a "vote of no confidence" made by faculty?
A "vote of no confidence" is much like a "resolution" passed by a parliamentary body—it's a statement of approved opinion, with very little legal impact. The only exception to this would occur if the voting body is in some way responsible for the appointment of the official in question, in which case such a vote could lead to removal. 

However, at the departmental level, such a vote has very little impact on the university as a whole.