No. Though not its own app, Google Discover appears on the Google app.
You will not need to download a separate Google Discover app; rather, if you have the Google app on your mobile device you will have access to Discover. On mobile devices, the Discover feed will also display on Google’s homepage in your browser.