Paddy O'Rourke, the former captain of the 1991 All-Ireland winning Down team, has been appointed as the county's new football manager.