While pretty much any distro can do this, I will warn you that it's not the greatest idea. GNOME and KDE are both massive software suites and you'll have a lot of redundant programs, e.g. two GUI file managers, and sometimes you'll get unexpected behavior. There are also some look and feel issues that might crop up with apps getting style hints from two places. Again, it's nothing super major, and it's been a while since I've done this so maybe it's improved, but any time I've tried I end up rolling back or reinstalling with only one big DE.

It's much less of an issue to have one big DE and then potentially several other more modular window managers, as those have much less opinionated payloads. I've got sway and hypr installed alongside GNOME.