A chapel where you can drink wine while listening to jazz, blues and bossa nova? Yes it does exist, it's called Capela Incomum in Porto, an old chapel that has been transformed into a wine bar.
The Vila Galé Porto Ribeira hotel stands right in front of the Douro River and has the theme painting. It is a hotel aimed at people over 16 years and designed for couples.