Brentford have appointed Keith Andrews as the club's new head coach on a three-year deal following Thomas Frank's departure to Tottenham.