Man started seeing 'a figure at the end of the bed' after putting up a haunted painting in his home