Change successful standby promotion message to log level 'NOTICE'

Was previously 'ERROR'.