Succession certificate is not required for immovable properties.
Revenue department cannot issue succession certificate.
The revenue department can issue legal heirship certificate but since your grandfather is reported to have died way back 59 years ago, they may not be in a position to verify the veracity and issue a certificate as desired.
However you may apply for one, get a reply stating their inability to provide the same, file a declaration suit in the competent civil court to declare the legal heirs/successors in interest to the deceased grandfather by impleading the Revenue department as defendant.
The succession affidavit issued by the Executive magistrate may be filed as documentary evidence to support your pleading seeking the said relief.
The district court may not be a proper court for this purpose.