Paddlefish need moving water to spawn... Other than that, they tend to stay in the backwaters of rivers, oxbow lakes and other slow moving/non-moving waters connected to rivers.
Just keep this in mind, if considering sturgeon, particularly lake and more northern river sturgeon... They require water qualities similar to trout. If your pond won't support trout or come darn near close to it, it probably won't support sturgeon.
