Conor Hourihane says he feels "emotional" after being appointed as head coach of League One Barnsley on a permanent basis.