Is auto-renewal facility available while opening the deposit?

No. Recurring deposits are not auto-renewed on maturity. The maturity proceeds are credited to your operative account.