Paraguayan President Santiago Peña has resigned following the collapse of Ueno Bank, which left nearly three million customers unable to access their accounts and triggered a major political crisis.