How do I add a description to the node title form field?
In a hook_form_alter() or hook_form_FORM_ID_alter(), add a description attribute to the node form element array:

 //Add a title field description
  $form['title']['#description'] = t('Enter your awesome title field details.');