The meaning of 养鱼 is entirely dependent on context.
In this context, the term is neutral and straightforward. It's used when talking about hobbies, aquaculture, pets, or feng shui.
This usage is highly informal and is most common among people under 40, especially online or when discussing relationships.