An Irish-American from "the most Irish town in America" has been named as the Navy SEAL who shot and killed Osama Bin Laden.