The mayor of the Texas city that was the site of one of the deadliest school shootings in U.S. history has announced his resignation, citing health issues