This feature is now complete and live. Guild owners and active members* that have Accept Member rights will now receive notifications for member join requests.
*Up to the top 10 members eligible will receive the notification.