The fish tank and fish inside, magic or not, are there to look good and as another object that the family can interact with. Although the magic fish in Fish Tycoon have benefits, they don't do anything special in this game besides look pretty as Xay mentioned.