A long-standing Fianna Fáil Kildare councillor has resigned from the party, following the identification of financial irregularities at a voluntary housing association.