Child navigation sidebar or drop-down navigation displaying child items
Drop-down menu from the main navigation menu, or some close
  alternative


Use Superfish. It integrates the jQuery Superfish dropdown plugin with your Drupal menus.


  Display all the children for that page in a sidebar


Use Menu Block. It provides configurable blocks of menu trees starting with any level of any menu. And more!