Your homeowner's policy will cover the tank and equipment similar to covering stuff in the house...but livestock such as coral and fish will not be covered.
As per flood damage, ask your carrier regarding tanks specifically, but in general they should be covered similar to having a bathtub overfill.
Lastly, there are riders for insurances that allow you to cover additional things that typically lie outside the homeowners policy (most riders are for expensive jewelry, wine, art, etc). Rarely if ever will riders cover animals, but if you pay enough, you can insure anything. The rider might be so expensive it's not worth the cost however.