[TRITON-MLIR][FRONTEND] Deprecate `triton-translate` and use `triton.compiler` submodule for unit tests

[ptillet]

Right now there is some code duplication, as the triton-translate utility does a subset of what the triton.compiler submodule is capable of. We should unify both so we don't have to maintain triton-translate when our optimization pipeline changes.