Magento 2 – How to Add Non-Category Drop Down Menu in Frontend

Here is the proper way to add a cms page link to the main menu without using the event page_block_html_topmenu_gethtml_before.
This way you will be able to add an active state to it also.
So create an observer in one of your modules that can look like this:

public function addCmsPage($observer) 
{
    //your page identifier
    $cmsPageIdentifier = 'page_idendifier_here';
    //get the menu instance
    $menu = $observer->getMenu();
    //load the page
    $page = Mage::getModel('cms/page')->load($cmsPageIdentifier, $identifier);
    //if the page exists
    if ($page->getId()) {
        $active = false;
        // Get the full action name for the request.
        $fullActionName = Mage::app()->getFrontController()->getAction()->getFullActionName();
        //check if we are on the view page action for the required page
        if ($fullActionName == 'cms_page_view') {
             $pageId = Mage::app()->getRequest()->getParam('page_id', $this->getRequest()->getParam('id', false)); 
             if ($pageId == $page->getId()) {
                 $active = true;
             }
        }
        //build a new menu item node
        $data = array(
            'name' => $page->getTitle(),
            'id' => 'cms-'.$cmsPageIdentifier,
            'url' => Mage::getUrl('', array('_direct'=>$cmsPageIdentifier)),
            'is_active' => $active
        );
        $pageNode = new Varien_Data_Tree_Node($data, 'id', $tree, $menu);
        //attach the node to the menu
        $menu->addChild($pageNode);
    }
}

You can roll your own or you can use Pronav that can do that and more. Visit the demo store to see it's possibilities.

We have very good experiences with several customers using this extension.

The "roll your own" version, aka magento topmenu-101:

1. The default top menu is only capable of generating a menu tree using the store categories
2. There's a large difference between the rwd top-menu and the other default design packages and that is that the rwd version only renders top-level categories.
3. Many have gone before you, borrow code, but don't borrow code that calls Mage::getModel('catalog/category)->load($id) for each menu item ( why not? - how to fix - slide 10 )
4. The top menu is inserted using a text_list (see page.xml in either base/default/layout or rwd/default/layout). This means the easiest way to add something to the menu is to add another block to that text list, provided that this works with the generated HTML.
5. Since 1.8.2 the topmenu now has support for a "renderer". This is code that used to be in the TopMenu block that recursively loads the menu tree and is now moved to the template. No more rewrites for simple adjustments, allthough the default file isn't your typical Magento template and frankly a quick hack.
6. Given 5, you can use your own renderer by extending Mage_Page_Block_Html_Topmenu_Renderer if needed and override the block type in a layout XML file.
7. Some people create empty categories in the catalog with URL keys that point to CMS pages or the home page, just so to make it appear in the top menu. This loads a bunch of overhead associated with categories that can be avoided using methods described in 4 to 6 and may need additional URL rewrites or layout updates to get working properly (/contact.html != /contact).
8. Typically, JavaScript provided interactivity is out of scope for MageStack, unless made very specific and being lucky somebody has that lying around or when it deals with bugs / configuration issues in the default installation.
9. Looking in skin/rwd/default/css/styles.css shows various class-based selectors with the keyword 'hide' and 'hidden' that aid in hiding an item by default.
10. See 8 on how to unhide something on the click event. Also see js/lib/dropdown.js for inspiration.

Hopefully this helps you get started and feel free to ask specific questions if you get stuck.