Rep. Trent Franks of Arizona, who asked staffers if they would bear his child as a surrogate, says he will resign