Demi Lovato has signed on to sing the national anthem at the Mayweather vs. McGregor fight on August 26 ... Showtime has confirmed