Do I need a fence if I install an automatic safety cover?

Yes.  An auto cover is one of the many “layers of protection” that also has many other benefits (like heat retention, assisting with keeping the pool clean) but it does not eliminate the need for a fence.