Ex-Republic of Ireland midfielder John Sheridan has been confirmed as Terry Butcher's replacement as Newport County manager.