This is an agreement with Club and Council and varies per council. 

A tenancy agreement can be for 6 months as it is a shared facility eg cricket; can be a long term lease/license as it is a football specific venue. 

The FFA does not have these agreements available as it is between club/governing body & council.

All Councils have some form of Tenancy Policy for sports clubs and the use of their facilities this can usually be found on your local Council websites.

Football NSW and Northern NSW Football - Football Facilities