A colourful exhibition featuring personal stories, artwork and photography around the subject of pride has gone on show.