We used to put indoor koi ponds in houses too.

From the pit standpoint, you could excavate the whole thing, put a sump in then build it two-level.

There’s always a way, it’s just not usually cheap.