A British councillor has resigned from the Conservative Party after making “thoughtless and extremely foolish” comments about immigrant school children.