The artist behind a quirky new bar in Dundee says he hopes the pub’s “unique” style will attract people from across the UK.