Powell, leaving mixed legacy on ‘Don’t Ask, Don’t Tell,’ was key figure once opposed gays in military, then backed review