Custom community error page to show "URL no longer exist"
I got the reason why my custom error page was not loading, along with assigning custom VF pages under site error page we also need to enable a setting under community preferences.
Thanks all for your comments and suggestions.