The term ornamental fish tickles me.

Koi fish are pleasant to watch. We have a big ole pond outside work with a few of them in, plus some goldfish and probably others. It's pretty nice.