Should the transformer be submerged in the pond?

No. The transformer is not designed to be submerged. Therefore, it should be placed in a dry discreet location outside of the pond.