The Counter Attack materia will let you counter attack with your normal physical attack when you are hit. The Counter materia will counter attack with the linked materia when you are attacked. So if you have Knights of the Round linked to a Counter materia you will counter attack with Knights of the Round when you are attacked.