In a tight and tense affair, Cardiff edged out Newport in the Premiership Cup final at Principality Stadium.