Topology on the set of partitions
There are several natural topologies to put on the space of partitions, which can also be thought of as the space of equivalence relations.
First, the collection of partitions of a set is a partial order under the refinement relation, where one partition $\mathcal{A}$ refines another $\mathcal{B}$ when every element of $\mathcal{A}$ is a subset of a set in $\mathcal{B}$. What's more, the space of partitions for each of your spaces is a lower semi-lattice, since any two partitions $\mathcal{A}$ and $\mathcal{B}$ have a coarsest common refinement, the collection of nonempty $A\cap B$, where $A\in\mathcal{A}$ and $B\in\mathcal{B}$. Indeed, the cases of $X$ and $Y$ lead to a $\sigma$-complete lower semi-lattice, since one may similarly intersect countably many sets and remain Borel or Lebesgue measurable as required. Since every partial order has a natural topology, the lower-cone topology, where the open sets are simply those that are closed downwards with respect to the order, we may place this topology on the space of partitions. In your case, the open sets of partitions would be those that include all refinements of any partition in the set.
This topology is compact---in the cases of $X$ and $Y$ and also in the case of the set of all partitions---simply because there is a coarsest partition, the partition with only one component consisting of the whole set. The only open neighborhood of this partition in the lower-cone topology is the entire space of partitions, since every partition refines it.
Secondly, a different dual topology would arise from turning the order upside down, and for that, the open sets would be closed under encoarsening rather than refinement. This topology also is compact, since there is a finest topology, consisting of the collection of singletons, and every partition is coarser than it.
Note that the space of all partitions, despite your remark on its complexity, actually exhibits much nicer lattice-theoretic properties than the Borel partitions or the measurable partitions. This is because the space of all partitions is actually a complete lattice. This is because any family of partitions has a largest common refinement, obtained simply by intersecting the equivalence relations as sets of ordered pairs. Similarly, one may take the equivalence relation generated by any family of partitions to find the smallest common encoarsening.
Another natural topology arises on the class of equivalence relations by saying that a basic open set is determined by finitely many equivalences and non-equivalences. Thus, one specifies finitely many equivalencies and non-equivalencies on the points $x_i\sim x_j$, $y_s\not\sim y_t$, and then the basic open set is the collection of all partitions that respect those finitely many requirements. This is a common kind of topology to place on the set of models of a first-order theory, where the basic open sets specify finitely much information about the predicates of the model; the collection of partitions amounts to the collection of equivalence relations, which is first-order.
One can imagine more elaborate topologies in this line, which take more into account your context of Lebesgue measurable or Borel partitions, by moving beyond finitely many point requirements to the case of finitely many requirements on Borel sets, or on measurable sets.
It would of course depend on your purpose with the topology to know which is best for that purpose.
Finally, let me mention that the well-developed theory of Borel equivalence relations is deeply concerned with the space of Borel partitions of the reals, but not exactly in your sense. What is usually required in that theory is not merely that every element of the partition is Borel, that is, that every equivalence class is Borel, but rather one insists that the binary relation itself, thought of as a subset of the plane, should be Borel. This is a more uniform kind of Borel, and the theory is extremely robust and active.