Two councils have agreed on moving ahead with a 92,000-panel solar farm which goes across agricultural land near Waterlooville.