All the off camera brands make lenses with Nikon mounts, Tokina, Tamron, Sigma.
Look at the used B&H photo site. You are looking for Dx format lenses. Not sure one lens does it all, kids, dog, fish tank...
The Nikon 18-200mm Dx VR lens has always been a good walk around lens. If you are looking to get serious about fish then a macro lens at some point.